﻿CREATE TABLE [dbo].[User] (
    [Id]            UNIQUEIDENTIFIER NOT NULL,
    [Username]      NVARCHAR (256)   NOT NULL,
    [Email]         NVARCHAR (256)   NOT NULL,
    [EmailVerified] BIT              NOT NULL,
    [Password]      NVARCHAR (256)   NOT NULL,
    [HashSalt]      NVARCHAR (128)   NOT NULL,
    [Role]          INT              NOT NULL,
    [CreateAt]      DATETIME2 (3)    NOT NULL,
    [Lockout]       BIT              NOT NULL,
    [LastActAt]     DATETIME2 (3)    NOT NULL,
    CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_User_Member] FOREIGN KEY ([Id]) REFERENCES [dbo].[Member] ([Id])
);













